Tabela ActiveIngredientGroupDetails

Definicja tabeli ActiveIngredientGroupDetails

Name

ActiveIngredientGroupDetails

Code

ActiveIngredientGroupDetails

Comment

PL:Dane (taryfy i min. dawki) grup substancji czynnych


Lista kolumn tabeli ActiveIngredientGroupDetails

Name

Code

activeIngredientGroupDetailsID

activeIngredientGroupDetailsID

activeIngredientGroupId

activeIngredientGroupId

typeId

typeId

startDT

startDT

stopDT

stopDT

unitsCount

unitsCount

baseTariff

baseTariff

minDose

minDose


Kolumna activeIngredientGroupDetailsID tabeli ActiveIngredientGroupDetails

Definicja kolumny activeIngredientGroupDetailsID tabeli ActiveIngredientGroupDetails

Name

activeIngredientGroupDetailsID

Code

activeIngredientGroupDetailsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna activeIngredientGroupId tabeli ActiveIngredientGroupDetails

Definicja kolumny activeIngredientGroupId tabeli ActiveIngredientGroupDetails

Name

activeIngredientGroupId

Code

activeIngredientGroupId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna typeId tabeli ActiveIngredientGroupDetails

Definicja kolumny typeId tabeli ActiveIngredientGroupDetails

Name

typeId

Code

typeId

Data Type

NUMBER(10)

Mandatory

No

Comment

rodzaj danych (taryfa lub min.dawka)


Kolumna startDT tabeli ActiveIngredientGroupDetails

Definicja kolumny startDT tabeli ActiveIngredientGroupDetails

Name

startDT

Code

startDT

Data Type

DATE

Mandatory

No

Comment

data poczatku obowiazywania


Kolumna stopDT tabeli ActiveIngredientGroupDetails

Definicja kolumny stopDT tabeli ActiveIngredientGroupDetails

Name

stopDT

Code

stopDT

Data Type

DATE

Mandatory

No

Comment

data konca obowiazywania


Kolumna unitsCount tabeli ActiveIngredientGroupDetails

Definicja kolumny unitsCount tabeli ActiveIngredientGroupDetails

Name

unitsCount

Code

unitsCount

Data Type

NUMBER(12)

Mandatory

No

Comment

liczba wycenionych jednostek miary


Kolumna baseTariff tabeli ActiveIngredientGroupDetails

Definicja kolumny baseTariff tabeli ActiveIngredientGroupDetails

Name

baseTariff

Code

baseTariff

Data Type

NUMBER(10,4)

Mandatory

No

Comment

taryfa progowa


Kolumna minDose tabeli ActiveIngredientGroupDetails

Definicja kolumny minDose tabeli ActiveIngredientGroupDetails

Name

minDose

Code

minDose

Data Type

NUMBER(14,6)

Mandatory

No

Comment

minimalna dawka


Lista kluczy tabeli ActiveIngredientGroupDetails

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ActiveIngredientGroupDetails

Definicja klucza Identifier_1 tabeli ActiveIngredientGroupDetails

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment